using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DTO;
namespace DAO
{
    class LoaiPhongDAO
    {
        private string strSQL = "";
        DataProvider dp = new DataProvider();
        public static DataTable getListLoaiPhong()
        {
            DataProvider dp = new DataProvider();
            string strSQL = "SELECT * FROM LOAIPHONG";
            return dp.ExecuteQuery(strSQL);
        }
        public int getDonGiaByLoaiPhong(string MaLoaiPhong)
        {
            strSQL = "Select DonGia from LoaiPhong Where MaLoaiPhong='" + MaLoaiPhong + "'";
            return dp.ExcuteScalar(strSQL);
        }
    }
}
